﻿CREATE TABLE [dbo].[Seat] (
    [Id]          INT          NOT NULL,
    [FlightId]    INT          IDENTITY (1, 1) NOT NULL,
    [SeatClassId] INT          NOT NULL,
    [Vertical]    VARCHAR (10) NOT NULL,
    [Horizontal]  VARCHAR (10) NOT NULL,
    [Status]      VARCHAR (50) NULL,
    CONSTRAINT [PK_Seat] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Seat_FlightSeatClassDetail] FOREIGN KEY ([FlightId], [SeatClassId]) REFERENCES [dbo].[FlightSeatClassDetail] ([FlightId], [SeatClassId])
);

